﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Bukong.aspx.cs" Inherits="Bukong_Bukong" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
    <style type="text/css">
        .style2
        {
            font-size: medium;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server">
    <span class="style2"><strong>补孔部分</strong></span><br />
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
    AutoGenerateColumns="False" DataKeyNames="JH,SBRQ" 
    DataSourceID="SqlDataSource1" ondatabound="GridView1_DataBound" 
        onrowupdating="GridView1_RowUpdating">
    <Columns>
        <asp:CommandField ShowEditButton="True" EditText="录入" />
        <asp:BoundField DataField="JH" HeaderText="井号" ReadOnly="True" 
            SortExpression="JH" />
        <asp:BoundField DataField="DH" HeaderText="队号" SortExpression="DH" />
        <asp:BoundField DataField="SBRQ" DataFormatString="{0:d}" HeaderText="上报日期" 
            ReadOnly="True" SortExpression="SBRQ" />
        <asp:BoundField DataField="KGRQ" DataFormatString="{0:d}" HeaderText="开工日期" 
            SortExpression="KGRQ" />
        <asp:BoundField DataField="WGRQ" DataFormatString="{0:d}" HeaderText="完工日期" 
            SortExpression="WGRQ" />
        <asp:BoundField DataField="SGFS" HeaderText="施工方式" SortExpression="SGFS" />
        <asp:BoundField DataField="CWSYHD" HeaderText="措施层位砂岩厚度" 
            SortExpression="CWSYHD" />
        <asp:BoundField DataField="CWYXHD" HeaderText="措施层位有效厚度" 
            SortExpression="CWYXHD" />
        <asp:BoundField DataField="CSCD" HeaderText="措施层段" SortExpression="CSCD" />
        <asp:BoundField DataField="SGJDDS1" HeaderText="施工层段顶深" 
            SortExpression="SGJDDS1" />
        <asp:BoundField DataField="SGJDDS2" HeaderText="施工层段低深" 
            SortExpression="SGJDDS2" />
    </Columns>
    <PagerSettings FirstPageImageUrl="~/Images/First.gif" 
        LastPageImageUrl="~/Images/Last.gif" 
        NextPageImageUrl="~/Images/Next.gif" 
        PreviousPageImageUrl="~/Images/Previous.gif" />
    <PagerStyle HorizontalAlign="Center" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:ConnectionStringForOracle %>" 
    DeleteCommand="DELETE FROM &quot;BC_BUKONG&quot; WHERE &quot;JH&quot; = :JH AND &quot;SBRQ&quot; = :SBRQ" 
    InsertCommand="INSERT INTO &quot;BC_BUKONG&quot; (&quot;JH&quot;, &quot;KGRQ&quot;, &quot;WGRQ&quot;, &quot;CWSYHD&quot;, &quot;CWYXHD&quot;, &quot;SBRQ&quot;, &quot;DH&quot;, &quot;CSCD&quot;, &quot;SGJDDS1&quot;, &quot;SGJDDS2&quot;) VALUES (:JH, :KGRQ, :WGRQ, :CWSYHD, :CWYXHD, :SBRQ, :DH, :CSCD, :SGJDDS1, :SGJDDS2)" 
    ProviderName="<%$ ConnectionStrings:ConnectionStringForOracle.ProviderName %>" 
    SelectCommand="SELECT &quot;JH&quot;, &quot;KGRQ&quot;, &quot;WGRQ&quot;,&quot;SGFS&quot;, &quot;CWSYHD&quot;, &quot;CWYXHD&quot;, &quot;SBRQ&quot;, &quot;DH&quot;, &quot;CSCD&quot;, &quot;SGJDDS1&quot;, &quot;SGJDDS2&quot; FROM &quot;BC_BUKONG&quot; WHERE ( (&quot;KGRQ&quot; IS NULL) OR (&quot;SGFS&quot; IS NULL) OR (&quot;WGRQ&quot; IS NULL) OR (&quot;CWSYHD&quot; IS NULL) OR (&quot;CWYXHD&quot; IS NULL) OR (&quot;CSCD&quot; IS NULL) OR (&quot;SGJDDS1&quot; IS NULL) OR (&quot;SGJDDS2&quot; IS NULL)) ORDER BY &quot;SBRQ&quot;" 
    
        
        
        UpdateCommand="UPDATE &quot;BC_BUKONG&quot; SET &quot;KGRQ&quot; = :KGRQ, &quot;WGRQ&quot; = :WGRQ, &quot;CWSYHD&quot; = :CWSYHD, &quot;CWYXHD&quot; = :CWYXHD, &quot;DH&quot; = :DH, &quot;CSCD&quot; = :CSCD, &quot;SGJDDS1&quot; = :SGJDDS1, &quot;SGJDDS2&quot; = :SGJDDS2 WHERE &quot;JH&quot; = :JH AND &quot;SBRQ&quot; = :SBRQ">
    <DeleteParameters>
        <asp:Parameter Name="JH" Type="String" />
        <asp:Parameter Name="SBRQ" Type="DateTime" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="JH" Type="String" />
        <asp:Parameter Name="KGRQ" Type="DateTime" />
        <asp:Parameter Name="WGRQ" Type="DateTime" />
        <asp:Parameter Name="CWSYHD" Type="Decimal" />
        <asp:Parameter Name="CWYXHD" Type="Decimal" />
        <asp:Parameter Name="SBRQ" Type="DateTime" />
        <asp:Parameter Name="DH" Type="String" />
        <asp:Parameter Name="CSCD" Type="String" />
        <asp:Parameter Name="SGJDDS1" Type="Decimal" />
        <asp:Parameter Name="SGJDDS2" Type="Decimal" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="KGRQ" Type="DateTime" />
        <asp:Parameter Name="WGRQ" Type="DateTime" />
        <asp:Parameter Name="CWSYHD" Type="Decimal" />
        <asp:Parameter Name="CWYXHD" Type="Decimal" />
        <asp:Parameter Name="DH" Type="String" />
        <asp:Parameter Name="CSCD" Type="String" />
        <asp:Parameter Name="SGJDDS1" Type="Decimal" />
        <asp:Parameter Name="SGJDDS2" Type="Decimal" />
        <asp:Parameter Name="JH" Type="String" />
        <asp:Parameter Name="SBRQ" Type="DateTime" />
    </UpdateParameters>
</asp:SqlDataSource>
</asp:Content>

